USE [AnotherSuccessfulProcedure]

IF EXISTS (SELECT * FROM sysobjects WHERE id = object_id(N'[dbo].[PlayersInsert]') AND OBJECTPROPERTY(id, N'IsProcedure') = 1)
BEGIN
	DROP PROCEDURE dbo.PlayersInsert
END


SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author:		Neil Wilson
-- Create date: 08/29/08
-- Description:	Players Table Insert
-- =============================================
CREATE PROCEDURE PlayersInsert

            @PlayerId varchar(30),
            @FirstSeen datetime,
            @LastSeen datetime
	

AS
BEGIN

INSERT INTO [Players]
           ([PlayerId]
           ,[FirstSeen]
           ,[LastSeen])
     VALUES
           (@PlayerId,
            @FirstSeen,
            @LastSeen)
END
GO
